{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Pricing sheet"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Pricing sheet","index":0,"n_rows":45,"n_cols":20,"rows_kept":45,"cut":false,"hidden":false,"merged":[[33,2,34,4],[7,3,7,4],[29,2,29,4],[39,2,39,4],[2,2,3,4],[17,6,18,7],[7,6,8,7],[12,6,12,7],[21,2,22,4],[2,6,2,7],[11,2,12,4],[8,3,8,4],[5,3,5,4],[4,3,4,4],[6,3,6,4],[9,3,9,4],[3,6,4,7]]}
[]
[]
[null,null,"Harvest Grain Pricing Sheet ",null,null,null,"Legend"]
[null,null,null,null,null,null,"Variables highlighted in Yellow are the inputs you can change that amend the pricing sheet, populating results automatically"]
[null,null,"Crop "]
[null,null,"Variety"]
[null,null,"Grain Grade"]
[null,null,"Total Hectares",800,null,null,"Tonnes of Sale Quick Calculator"]
[null,null,"Crop Hectares ",50]
[null,null,"Seasonal Cycle",null,null,null,"Tonnes of Sale",40]
[null,null,null,null,null,null,"Sale Price",350]
[null,null,"Harvest Costs",null,null,null,"Cost Per Tonne",{"$f":"E26","v":156.25}]
[]
[null,null,null,"Total Costs","Cost per Hectare",null,"Revenue ",{"$f":"H10*H11","v":14000}]
[null,null,"Seed",5000,{"$f":"D15/$D$8","v":6.25},null,"Cost of Sale",{"$f":"H10*H12","v":6250}]
[null,null,"Fertilizer",10000,{"$f":"D16/$D$8","v":12.5},null,"Profit Margin",{"$f":"H14-H15","v":7750}]
[null,null,"Chemical ",5000,{"$f":"D17/$D$8","v":6.25}]
[null,null,"Urea ",80000,{"$f":"D18/$D$8","v":100},null,"Acreage Margin Calculator"]
[null,null,"Cost per Hectare",null,{"$f":"SUM(E15:E18)","v":125}]
[null,null,"Total cost",null,{"$f":"E19*D9","v":6250},null,"Seed",{"$f":"E15*$D$9","v":312.5}]
[null,null,null,null,null,null,"Fertilizer",{"$f":"E16*$D$9","v":625}]
[null,null,"Yield",null,null,null,"Chemical ",{"$f":"E17*$D$9","v":312.5}]
[null,null,null,null,null,null,"Urea ",{"$f":"E18*$D$9","v":5000}]
[null,null,"Tonnes Harvested",null,40,null,"Profit Margin",{"$f":"E29-E20","v":7750}]
[null,null,"Yield per Hectare (t/hc)",null,{"$f":"E24/$D$9","v":0.8}]
[null,null,"Cost per Tonne",null,{"$f":" E19/ (E24 / $D$9)","v":156.25},null,"El Niño"]
[null,null,"Current Price",null,350,null,"La Niña"]
[null,null,"Margin Per Tonne",null,{"$f":"E27-E26","v":193.75}]
[null,null,"Gross Revenue",null,{"$f":"E24*E27","v":14000}]
[null,null,null,null,null,null,"Yield per Hectare (t/hc)"]
[null,null,"Yield's Profit",null,{"$f":"E29-E20","v":7750},null,"Yield per acre (t/ac)"]
[null,null,"Total Margin",null,{"$f":"E28*E24","v":7750},null,"Total Hectares"]
[null,null,null,null,null,null,"Total Acres ",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"Warehousing"]
[null,null,null,null,null,null,"Crop Hectares "]
[null,null,"Cost Per Month",null,2,null,"Crop Acreage"]
[null,null,"Total Tonnes",null,40]
[null,null,"Months Stored ",null,{"$f":"6","v":6},null,"Cost per Hectare"]
[null,null,"Total Storage Cost",null,{"$f":"(E36*E37)*E38","v":480},null,"Cost per acre"]
[]
[null,null,"Profit After Storage",null,{"$f":"E31-E39","v":7270}]
[]
[]
[null,null,"Creator: ","Robert Cain"]
[null,null,"Email: ","cainsolutions97@gmail.com"]